﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/MasterPage.master" AutoEventWireup="true" CodeFile="ViewAcountHolidays.aspx.cs" Inherits="WorkTime_ViewAcountHolidays" %>

<%@ Register Src="../Control/DepartmentDList.ascx" TagName="DepartmentDList" TagPrefix="uc1" %>
<%@ Register Src="../Control/SelYear.ascx" TagName="SelYear" TagPrefix="uc2" %>
<%@ Register Src="../Control/SelUser.ascx" TagName="SelUser" TagPrefix="uc3" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Titile" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Content" Runat="Server">
<table cellpadding="0" cellspacing="5" class="TbSearch">
        <tr>
            
            <td style="width:40px">
                部门：
            </td>
            <td>
                <uc1:DepartmentDList ID="dplist" runat="server" />
            </td>
            <td style="width:40px">
                员工：
            </td>
            <td>
                <uc3:SelUser ID="SelUser1" runat="server" />
            </td>
            <td style="width: 200px; text-align: center">
            
            <span class="roundbtn">
                    <asp:LinkButton ID="btnSearch" runat="server" Text=" 年 假 查 询 " OnClick="btnSearch_Click"
                        ></asp:LinkButton>
                </span>
                
            </td>
        </tr>
    </table>
    <infolight:webgridview runat="server" cellpadding="5" forecolor="#333333" width="100%"
        aborticonurl="../Image/UIPics/Abort.gif" addiconurl="../Image/UIPics/Add.gif"
        applyiconurl="../Image/UIPics/Apply.gif" canceliconurl="../Image/UIPics/Cancel.gif"
        mouseoveraborticonurl="../Image/UIPics/Abort2.gif" mouseoveraddiconurl="../Image/UIPics/Add2.gif"
        mouseoverapplyiconurl="../Image/UIPics/Apply2.gif" mouseovercanceliconurl="../Image/UIPics/Cancel2.gif"
        mouseoverokiconurl="../Image/UIPics/OK2.gif" mouseoverqueryiconurl="../Image/UIPics/Query2.gif"
        okiconurl="../Image/UIPics/OK.gif" 
        queryiconurl="../Image/UIPics/Query.gif" headerstylewrap="False"
        backcolor="White" bordercolor="White" borderstyle="Groove" borderwidth="2px"
        pagesize="15" id="GVHoliday" datasourceid="Master" 
        onrowdatabound="GVHoliday_RowDataBound">
        <columns>
            <asp:TemplateField HeaderText="详细">
                <ItemTemplate>
                    <asp:ImageButton ID="ibdetail" runat="server" 
                        ImageUrl="~/Image/MenuTree/288688.png" />
                </ItemTemplate>
                <ItemStyle HorizontalAlign="Center" />
            </asp:TemplateField>
            <asp:BoundField DataField="EmployeeID" HeaderText="员工工号" SortExpression="EmployeeID" />
            <asp:BoundField DataField="EmpName" HeaderText="员工姓名" SortExpression="EmpName" />
            <asp:BoundField DataField="DepartmentName" HeaderText="部门" SortExpression="DepartmentName" />
            <asp:BoundField HeaderText="所剩年假数（天）" SortExpression="YearDate" 
                DataField="YearDate" NullDisplayText="0"/>
           
        </columns>
        <pagersettings mode="NumericFirstLast" />
        <footerstyle backcolor="#507CD1" forecolor="White" font-bold="True"></footerstyle>
        <rowstyle backcolor="#EFF3FB"></rowstyle>
        <editrowstyle backcolor="#2461BF"></editrowstyle>
        <navcontrols>
            <InfoLight:ControlItem ControlName="Add" ControlText="add" ControlType="Image" 
                ControlVisible="False" DisenableImageUrl="../image/uipics/add3.gif" 
                ImageUrl="../image/uipics/add.gif" MouseOverImageUrl="../image/uipics/add2.gif" 
                Size="25" />
            <InfoLight:ControlItem ControlName="Query" ControlText="query" 
                ControlType="Image" ControlVisible="False" 
                DisenableImageUrl="../image/uipics/query3.gif" 
                ImageUrl="../image/uipics/query.gif" 
                MouseOverImageUrl="../image/uipics/query2.gif" Size="25" />
            <InfoLight:ControlItem ControlName="Apply" ControlText="apply" 
                ControlType="Image" ControlVisible="False" 
                DisenableImageUrl="../image/uipics/apply3.gif" 
                ImageUrl="../image/uipics/apply.gif" 
                MouseOverImageUrl="../image/uipics/apply2.gif" Size="25" />
            <InfoLight:ControlItem ControlName="Abort" ControlText="abort" 
                ControlType="Image" ControlVisible="False" 
                DisenableImageUrl="../image/uipics/abort3.gif" 
                ImageUrl="../image/uipics/abort.gif" 
                MouseOverImageUrl="../image/uipics/abort2.gif" Size="25" />
            <InfoLight:ControlItem ControlName="OK" ControlText="Insert" 
                ControlType="Image" ControlVisible="False" 
                DisenableImageUrl="../image/uipics/ok3.gif" ImageUrl="../image/uipics/ok.gif" 
                MouseOverImageUrl="../image/uipics/ok2.gif" Size="25" />
            <InfoLight:ControlItem ControlName="Cancel" ControlText="cancel" 
                ControlType="Image" ControlVisible="False" 
                DisenableImageUrl="../image/uipics/cancel3.gif" 
                ImageUrl="../image/uipics/cancel.gif" 
                MouseOverImageUrl="../image/uipics/cancel2.gif" Size="25" />
        </navcontrols>
        <selectedrowstyle backcolor="#D1DDF1" forecolor="#333333" font-bold="True"></selectedrowstyle>
        <pagerstyle backcolor="LightBlue" forecolor="White" horizontalalign="Center"></pagerstyle>
        <headerstyle backcolor="DeepSkyBlue" forecolor="White" font-bold="True"></headerstyle>
        <alternatingrowstyle backcolor="White" bordercolor="White"></alternatingrowstyle>
    </infolight:webgridview>
    <infolight:webdatasource id="Master" runat="server" selectalias="Usasdb" selectcommand="select Employees.EmployeeId,Employees.EmpName,cast(sum(Days) as decimal(4,2)) AS YearDate,Department.DepartmentName  from Employees
left join WorkTime_YearHoliday on (Employees.EmployeeId=WorkTime_YearHoliday.EmployeeId)
left join Department on 
(Department.DepartmentId=Employees.DepartmentId)
where Employees.EmpStatus=1
group by  Employees.EmployeeId,Employees.EmpName,Department.DepartmentName
order by Employees.EmployeeId" CacheDataSet="True">
    </infolight:webdatasource>
</asp:Content>

